TG: sql_for_qa/94

SQL для тестировщика

Дана таблица "orders" c колонками "order_id", "customer_id", "order_date" и "total_amount". Какой из следующих SQL запросов выведет общую сумму заказов в разрезе покупателей?

Anonymous Quiz

SELECT customer_id, COUNT(order_id) FROM orders GROUP BY customer_id;

SELECT customer_id, AVG(total_amount) FROM orders GROUP BY customer_id;

SELECT customer_id, MAX(total_amount) FROM orders GROUP BY customer_id;

SELECT customer_id, SUM(total_amount) FROM orders GROUP BY customer_id;

542 answered

www.tg-me.com/ar/SQL для тестировщика/com.sql_for_qa/94

2.5K viewsMay 19, 2023 at 11:12

tg-me.com/sql_for_qa/94

Create: 2023-05-19
Last Update: 2025-07-02 19:53:55

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/94

SQL для тестировщика Telegram | DID YOU KNOW?

TG: sql_for_qa/94